Download Provisioning SQL Databases.70-765.Test4Prep.2018-11-16.106q.vcex

A URL specifies a Uniform Resource Identifier (URI) to a unique backup file. The URL is used to provide the location and name of the SQL Server backup file. The URL must point to an actual blob, not just a container. If the blob does not exist, it is created. If an existing blob is specified, BACKUP fails, unless the “WITH FORMAT” option is specified to overwrite the existing backup file in the blob. LOCALLY REDUNDANT STORAGE (LRS) makes multiple synchronous copies of your data within a single datacenter. Incorrect Answers:F: Zone redundant blob storage would be me more expensive as it stores three copies of data across multiple datacenters within or across regions.References:https://msdn.microsoft.com/en-us/library/dn435916.aspxhttps://azure.microsoft.com/en-us/pricing/details/storage/blobs/

Premium Storage Disks Limits When you provision a disk against a Premium Storage account, how much input/output operations per second (IOPS) and throughput (bandwidth) it can get depends on the size of the disk. Currently, there are three types of Premium Storage disks: P10, P20, and P30. Each one has specific limits for IOPS and throughput as specified in the following table:  References: https://docs.microsoft.com/en-us/azure/storage/storage-premium-storage

For a database size of 500 GB the Premium tier is required. Both P1 and P2 are adequate. P1 is preferred as it is cheaper. Note:  Incorrect Answers:A, C: Maximum database size is 250 GB for the Standard pricing tier.References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers

In SQL Database, the relative measure of a database's ability to handle resource demands is expressed in Database Transaction Units (DTUs) for single databases and elastic DTUs (eDTUs) for databases in an elastic pool. A pool is given a set number of eDTUs, for a set price. Within the pool, individual databases are given the flexibility to auto-scale within set parameters. Under heavy load, a database can consume more eDTUs to meet demand. Additional eDTUs can be added to an existing pool with no database downtime. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-transact-sql#add-secondary-database

Always On availability groups supports two availability modes—asynchronous-commit mode and synchronous-commit mode Synchronous-commit mode emphasizes high availability over performance, at the cost of increased transaction latency. References: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups#SyncCommitAvMode

To set up a readable secondary replica, you first create an availability group. Then you add replicas. You can choose either Yes or Read-intent only options.   References: http://msdn.microsoft.com/en-us/library/jj542414.aspx

You would need to use either the SQL Server Management Studio or Transact-SQL. References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate

A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. B: In the contained database user model, the login in the master database is not present. Instead, the authentication process occurs at the user database, and the database user in the user database does not have an associated login in the master database.SQL Database and SQL Data Warehouse support Azure Active Directory identities as contained database users. D: The contained database feature is currently available only in a partially contained state. A partially contained database is a contained database that allows the use of uncontained features.References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases